/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package converter.core.db.entity;

import java.io.Serializable;
import java.math.BigInteger;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 *
 * @author Snark
 */
@Entity
@Table(name = "SYS_AU_TABLES")
@NamedQueries({
    @NamedQuery(name = "SysAuTables.findAll", query = "SELECT s FROM SysAuTables s"),
    @NamedQuery(name = "SysAuTables.findBySysFldorder", query = "SELECT s FROM SysAuTables s WHERE s.sysFldorder = :sysFldorder"),
    @NamedQuery(name = "SysAuTables.findBySysGuid", query = "SELECT s FROM SysAuTables s WHERE s.sysGuid = :sysGuid"),
    @NamedQuery(name = "SysAuTables.findBySysState", query = "SELECT s FROM SysAuTables s WHERE s.sysState = :sysState"),
    @NamedQuery(name = "SysAuTables.findBySysRev", query = "SELECT s FROM SysAuTables s WHERE s.sysRev = :sysRev"),
    @NamedQuery(name = "SysAuTables.findBySysCreated", query = "SELECT s FROM SysAuTables s WHERE s.sysCreated = :sysCreated"),
    @NamedQuery(name = "SysAuTables.findBySysUpdated", query = "SELECT s FROM SysAuTables s WHERE s.sysUpdated = :sysUpdated"),
    @NamedQuery(name = "SysAuTables.findBySysCreator", query = "SELECT s FROM SysAuTables s WHERE s.sysCreator = :sysCreator"),
    @NamedQuery(name = "SysAuTables.findBySysUser", query = "SELECT s FROM SysAuTables s WHERE s.sysUser = :sysUser"),
    @NamedQuery(name = "SysAuTables.findBySysGuidfk", query = "SELECT s FROM SysAuTables s WHERE s.sysGuidfk = :sysGuidfk"),
    @NamedQuery(name = "SysAuTables.findBySysParentguid", query = "SELECT s FROM SysAuTables s WHERE s.sysParentguid = :sysParentguid"),
    @NamedQuery(name = "SysAuTables.findByIsgroup", query = "SELECT s FROM SysAuTables s WHERE s.isgroup = :isgroup"),
    @NamedQuery(name = "SysAuTables.findByTableGuid", query = "SELECT s FROM SysAuTables s WHERE s.tableGuid = :tableGuid"),
    @NamedQuery(name = "SysAuTables.findByAlias", query = "SELECT s FROM SysAuTables s WHERE s.alias = :alias"),
    @NamedQuery(name = "SysAuTables.findByDetailfield", query = "SELECT s FROM SysAuTables s WHERE s.detailfield = :detailfield"),
    @NamedQuery(name = "SysAuTables.findByBasedetailset", query = "SELECT s FROM SysAuTables s WHERE s.basedetailset = :basedetailset"),
    @NamedQuery(name = "SysAuTables.findByDetailalias", query = "SELECT s FROM SysAuTables s WHERE s.detailalias = :detailalias"),
    @NamedQuery(name = "SysAuTables.findByLookupdisplay", query = "SELECT s FROM SysAuTables s WHERE s.lookupdisplay = :lookupdisplay"),
    @NamedQuery(name = "SysAuTables.findByVisible", query = "SELECT s FROM SysAuTables s WHERE s.visible = :visible"),
    @NamedQuery(name = "SysAuTables.findByReadonly", query = "SELECT s FROM SysAuTables s WHERE s.readonly = :readonly"),
    @NamedQuery(name = "SysAuTables.findByMincount", query = "SELECT s FROM SysAuTables s WHERE s.mincount = :mincount"),
    @NamedQuery(name = "SysAuTables.findByMaxcount", query = "SELECT s FROM SysAuTables s WHERE s.maxcount = :maxcount"),
    @NamedQuery(name = "SysAuTables.findByPrefix", query = "SELECT s FROM SysAuTables s WHERE s.prefix = :prefix"),
    @NamedQuery(name = "SysAuTables.findByUseridfld", query = "SELECT s FROM SysAuTables s WHERE s.useridfld = :useridfld"),
    @NamedQuery(name = "SysAuTables.findByNamefld", query = "SELECT s FROM SysAuTables s WHERE s.namefld = :namefld"),
    @NamedQuery(name = "SysAuTables.findByRolefk", query = "SELECT s FROM SysAuTables s WHERE s.rolefk = :rolefk"),
    @NamedQuery(name = "SysAuTables.findByMultiselection", query = "SELECT s FROM SysAuTables s WHERE s.multiselection = :multiselection"),
    @NamedQuery(name = "SysAuTables.findByMultilookupfield", query = "SELECT s FROM SysAuTables s WHERE s.multilookupfield = :multilookupfield"),
    @NamedQuery(name = "SysAuTables.findByMultiisunique", query = "SELECT s FROM SysAuTables s WHERE s.multiisunique = :multiisunique"),
    @NamedQuery(name = "SysAuTables.findByCaneditinchooser", query = "SELECT s FROM SysAuTables s WHERE s.caneditinchooser = :caneditinchooser"),
    @NamedQuery(name = "SysAuTables.findByOrderby", query = "SELECT s FROM SysAuTables s WHERE s.orderby = :orderby"),
    @NamedQuery(name = "SysAuTables.findByGroupby", query = "SELECT s FROM SysAuTables s WHERE s.groupby = :groupby"),
    @NamedQuery(name = "SysAuTables.findByHidecard", query = "SELECT s FROM SysAuTables s WHERE s.hidecard = :hidecard"),
    @NamedQuery(name = "SysAuTables.findByHidefromtree", query = "SELECT s FROM SysAuTables s WHERE s.hidefromtree = :hidefromtree"),
    @NamedQuery(name = "SysAuTables.findByMultiselfields", query = "SELECT s FROM SysAuTables s WHERE s.multiselfields = :multiselfields"),
    @NamedQuery(name = "SysAuTables.findByExpanded", query = "SELECT s FROM SysAuTables s WHERE s.expanded = :expanded")})
public class SysAuTables implements Serializable {
    private static final long serialVersionUID = 1L;
    @Column(name = "SYS_FLDORDER")
    private Integer sysFldorder;
    @Id
    @Basic(optional = false)
    @Column(name = "SYS_GUID")
    private String sysGuid;
    @Column(name = "SYS_STATE")
    private Integer sysState;
    @Column(name = "SYS_REV")
    private BigInteger sysRev;
    @Column(name = "SYS_CREATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysCreated;
    @Column(name = "SYS_UPDATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysUpdated;
    @Column(name = "SYS_CREATOR")
    private String sysCreator;
    @Column(name = "SYS_USER")
    private String sysUser;
    @Column(name = "SYS_GUIDFK")
    private String sysGuidfk;
    @Column(name = "SYS_PARENTGUID")
    private String sysParentguid;
    @Column(name = "ISGROUP")
    private Integer isgroup;
    @Column(name = "TABLE_GUID")
    private String tableGuid;
    @Column(name = "ALIAS")
    private String alias;
    @Lob
    @Column(name = "EXRTRASQL")
    private String exrtrasql;
    @Lob
    @Column(name = "FILTER")
    private String filter;
    @Lob
    @Column(name = "EXPORTFILTER")
    private String exportfilter;
    @Column(name = "DETAILFIELD")
    private String detailfield;
    @Column(name = "BASEDETAILSET")
    private String basedetailset;
    @Lob
    @Column(name = "DETAILSCRIPT")
    private String detailscript;
    @Column(name = "DETAILALIAS")
    private String detailalias;
    @Column(name = "LOOKUPDISPLAY")
    private String lookupdisplay;
    @Lob
    @Column(name = "LOOKUPFILTER")
    private String lookupfilter;
    @Column(name = "VISIBLE")
    private Integer visible;
    @Column(name = "READONLY")
    private Integer readonly;
    @Column(name = "MINCOUNT")
    private Integer mincount;
    @Column(name = "MAXCOUNT")
    private Integer maxcount;
    @Lob
    @Column(name = "GENFLTQUERY")
    private String genfltquery;
    @Column(name = "PREFIX")
    private String prefix;
    @Column(name = "USERIDFLD")
    private String useridfld;
    @Column(name = "NAMEFLD")
    private String namefld;
    @Column(name = "ROLEFK")
    private String rolefk;
    @Lob
    @Column(name = "USERGENFILTER")
    private String usergenfilter;
    @Lob
    @Column(name = "CANAPPEND")
    private String canappend;
    @Lob
    @Column(name = "CANUPDATE")
    private String canupdate;
    @Lob
    @Column(name = "CANDELETE")
    private String candelete;
    @Lob
    @Column(name = "SUBTABS")
    private String subtabs;
    @Column(name = "MULTISELECTION")
    private Integer multiselection;
    @Column(name = "MULTILOOKUPFIELD")
    private String multilookupfield;
    @Column(name = "MULTIISUNIQUE")
    private Integer multiisunique;
    @Column(name = "CANEDITINCHOOSER")
    private Integer caneditinchooser;
    @Lob
    @Column(name = "MULTIFILTER")
    private String multifilter;
    @Lob
    @Column(name = "FIELDSLIST")
    private String fieldslist;
    @Column(name = "ORDERBY")
    private String orderby;
    @Column(name = "GROUPBY")
    private String groupby;
    @Column(name = "HIDECARD")
    private Integer hidecard;
    @Column(name = "HIDEFROMTREE")
    private Integer hidefromtree;
    @Column(name = "MULTISELFIELDS")
    private String multiselfields;
    @Lob
    @Column(name = "WP_TEMPLATE")
    private String wpTemplate;
    @Column(name = "EXPANDED")
    private Integer expanded;

    public SysAuTables() {
    }

    public SysAuTables(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysFldorder() {
        return sysFldorder;
    }

    public void setSysFldorder(Integer sysFldorder) {
        this.sysFldorder = sysFldorder;
    }

    public String getSysGuid() {
        return sysGuid;
    }

    public void setSysGuid(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysState() {
        return sysState;
    }

    public void setSysState(Integer sysState) {
        this.sysState = sysState;
    }

    public BigInteger getSysRev() {
        return sysRev;
    }

    public void setSysRev(BigInteger sysRev) {
        this.sysRev = sysRev;
    }

    public Date getSysCreated() {
        return sysCreated;
    }

    public void setSysCreated(Date sysCreated) {
        this.sysCreated = sysCreated;
    }

    public Date getSysUpdated() {
        return sysUpdated;
    }

    public void setSysUpdated(Date sysUpdated) {
        this.sysUpdated = sysUpdated;
    }

    public String getSysCreator() {
        return sysCreator;
    }

    public void setSysCreator(String sysCreator) {
        this.sysCreator = sysCreator;
    }

    public String getSysUser() {
        return sysUser;
    }

    public void setSysUser(String sysUser) {
        this.sysUser = sysUser;
    }

    public String getSysGuidfk() {
        return sysGuidfk;
    }

    public void setSysGuidfk(String sysGuidfk) {
        this.sysGuidfk = sysGuidfk;
    }

    public String getSysParentguid() {
        return sysParentguid;
    }

    public void setSysParentguid(String sysParentguid) {
        this.sysParentguid = sysParentguid;
    }

    public Integer getIsgroup() {
        return isgroup;
    }

    public void setIsgroup(Integer isgroup) {
        this.isgroup = isgroup;
    }

    public String getTableGuid() {
        return tableGuid;
    }

    public void setTableGuid(String tableGuid) {
        this.tableGuid = tableGuid;
    }

    public String getAlias() {
        return alias;
    }

    public void setAlias(String alias) {
        this.alias = alias;
    }

    public String getExrtrasql() {
        return exrtrasql;
    }

    public void setExrtrasql(String exrtrasql) {
        this.exrtrasql = exrtrasql;
    }

    public String getFilter() {
        return filter;
    }

    public void setFilter(String filter) {
        this.filter = filter;
    }

    public String getExportfilter() {
        return exportfilter;
    }

    public void setExportfilter(String exportfilter) {
        this.exportfilter = exportfilter;
    }

    public String getDetailfield() {
        return detailfield;
    }

    public void setDetailfield(String detailfield) {
        this.detailfield = detailfield;
    }

    public String getBasedetailset() {
        return basedetailset;
    }

    public void setBasedetailset(String basedetailset) {
        this.basedetailset = basedetailset;
    }

    public String getDetailscript() {
        return detailscript;
    }

    public void setDetailscript(String detailscript) {
        this.detailscript = detailscript;
    }

    public String getDetailalias() {
        return detailalias;
    }

    public void setDetailalias(String detailalias) {
        this.detailalias = detailalias;
    }

    public String getLookupdisplay() {
        return lookupdisplay;
    }

    public void setLookupdisplay(String lookupdisplay) {
        this.lookupdisplay = lookupdisplay;
    }

    public String getLookupfilter() {
        return lookupfilter;
    }

    public void setLookupfilter(String lookupfilter) {
        this.lookupfilter = lookupfilter;
    }

    public Integer getVisible() {
        return visible;
    }

    public void setVisible(Integer visible) {
        this.visible = visible;
    }

    public Integer getReadonly() {
        return readonly;
    }

    public void setReadonly(Integer readonly) {
        this.readonly = readonly;
    }

    public Integer getMincount() {
        return mincount;
    }

    public void setMincount(Integer mincount) {
        this.mincount = mincount;
    }

    public Integer getMaxcount() {
        return maxcount;
    }

    public void setMaxcount(Integer maxcount) {
        this.maxcount = maxcount;
    }

    public String getGenfltquery() {
        return genfltquery;
    }

    public void setGenfltquery(String genfltquery) {
        this.genfltquery = genfltquery;
    }

    public String getPrefix() {
        return prefix;
    }

    public void setPrefix(String prefix) {
        this.prefix = prefix;
    }

    public String getUseridfld() {
        return useridfld;
    }

    public void setUseridfld(String useridfld) {
        this.useridfld = useridfld;
    }

    public String getNamefld() {
        return namefld;
    }

    public void setNamefld(String namefld) {
        this.namefld = namefld;
    }

    public String getRolefk() {
        return rolefk;
    }

    public void setRolefk(String rolefk) {
        this.rolefk = rolefk;
    }

    public String getUsergenfilter() {
        return usergenfilter;
    }

    public void setUsergenfilter(String usergenfilter) {
        this.usergenfilter = usergenfilter;
    }

    public String getCanappend() {
        return canappend;
    }

    public void setCanappend(String canappend) {
        this.canappend = canappend;
    }

    public String getCanupdate() {
        return canupdate;
    }

    public void setCanupdate(String canupdate) {
        this.canupdate = canupdate;
    }

    public String getCandelete() {
        return candelete;
    }

    public void setCandelete(String candelete) {
        this.candelete = candelete;
    }

    public String getSubtabs() {
        return subtabs;
    }

    public void setSubtabs(String subtabs) {
        this.subtabs = subtabs;
    }

    public Integer getMultiselection() {
        return multiselection;
    }

    public void setMultiselection(Integer multiselection) {
        this.multiselection = multiselection;
    }

    public String getMultilookupfield() {
        return multilookupfield;
    }

    public void setMultilookupfield(String multilookupfield) {
        this.multilookupfield = multilookupfield;
    }

    public Integer getMultiisunique() {
        return multiisunique;
    }

    public void setMultiisunique(Integer multiisunique) {
        this.multiisunique = multiisunique;
    }

    public Integer getCaneditinchooser() {
        return caneditinchooser;
    }

    public void setCaneditinchooser(Integer caneditinchooser) {
        this.caneditinchooser = caneditinchooser;
    }

    public String getMultifilter() {
        return multifilter;
    }

    public void setMultifilter(String multifilter) {
        this.multifilter = multifilter;
    }

    public String getFieldslist() {
        return fieldslist;
    }

    public void setFieldslist(String fieldslist) {
        this.fieldslist = fieldslist;
    }

    public String getOrderby() {
        return orderby;
    }

    public void setOrderby(String orderby) {
        this.orderby = orderby;
    }

    public String getGroupby() {
        return groupby;
    }

    public void setGroupby(String groupby) {
        this.groupby = groupby;
    }

    public Integer getHidecard() {
        return hidecard;
    }

    public void setHidecard(Integer hidecard) {
        this.hidecard = hidecard;
    }

    public Integer getHidefromtree() {
        return hidefromtree;
    }

    public void setHidefromtree(Integer hidefromtree) {
        this.hidefromtree = hidefromtree;
    }

    public String getMultiselfields() {
        return multiselfields;
    }

    public void setMultiselfields(String multiselfields) {
        this.multiselfields = multiselfields;
    }

    public String getWpTemplate() {
        return wpTemplate;
    }

    public void setWpTemplate(String wpTemplate) {
        this.wpTemplate = wpTemplate;
    }

    public Integer getExpanded() {
        return expanded;
    }

    public void setExpanded(Integer expanded) {
        this.expanded = expanded;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (sysGuid != null ? sysGuid.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof SysAuTables)) {
            return false;
        }
        SysAuTables other = (SysAuTables) object;
        if ((this.sysGuid == null && other.sysGuid != null) || (this.sysGuid != null && !this.sysGuid.equals(other.sysGuid))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "javaapplication1.entity.SysAuTables[ sysGuid=" + sysGuid + " ]";
    }
    
}
